package com.aidex.system.mapper;

import com.aidex.system.domain.SysNotice;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SysNoticeMapper extends BaseMapper<SysNotice> {
    @Select("select t.* from sys_notice t left join sys_notice_user_read ur on t.id = ur.notice_id where ur.user_id = ${userId} and t.del_flag = '0'")
    List<SysNotice> selectNoticeListByUserId(@Param("userId") String userId);
}
